{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import string\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>colA</th>\n",
       "      <th>colB</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>a</th>\n",
       "      <td>0.964060</td>\n",
       "      <td>0.504881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>b</th>\n",
       "      <td>0.676013</td>\n",
       "      <td>0.297019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>c</th>\n",
       "      <td>0.178266</td>\n",
       "      <td>0.276179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>d</th>\n",
       "      <td>0.753107</td>\n",
       "      <td>0.654853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>e</th>\n",
       "      <td>0.677125</td>\n",
       "      <td>0.825303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>f</th>\n",
       "      <td>0.551150</td>\n",
       "      <td>0.032844</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>g</th>\n",
       "      <td>0.873431</td>\n",
       "      <td>0.417495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>h</th>\n",
       "      <td>0.710550</td>\n",
       "      <td>0.964441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>i</th>\n",
       "      <td>0.615627</td>\n",
       "      <td>0.075840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>j</th>\n",
       "      <td>0.913299</td>\n",
       "      <td>0.907235</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       colA      colB\n",
       "a  0.964060  0.504881\n",
       "b  0.676013  0.297019\n",
       "c  0.178266  0.276179\n",
       "d  0.753107  0.654853\n",
       "e  0.677125  0.825303\n",
       "f  0.551150  0.032844\n",
       "g  0.873431  0.417495\n",
       "h  0.710550  0.964441\n",
       "i  0.615627  0.075840\n",
       "j  0.913299  0.907235"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = pd.DataFrame({\n",
    "    'colA': np.random.rand(10),\n",
    "    'colB': np.random.rand(10),\n",
    "}, index=list(string.ascii_lowercase[:10]))\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>a</th>\n",
       "      <th>b</th>\n",
       "      <th>c</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>row1-cola</td>\n",
       "      <td>row1-colb</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>row2-cola</td>\n",
       "      <td>NaN</td>\n",
       "      <td>row2-colc</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           a          b          c\n",
       "0  row1-cola  row1-colb        NaN\n",
       "1  row2-cola        NaN  row2-colc"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = pd.DataFrame([\n",
    "    { 'a': 'row1-cola', 'b': 'row1-colb' },\n",
    "    { 'a': 'row2-cola', 'c': 'row2-colc' }\n",
    "])\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'images': [{'bot': 1,\n",
       "   'copyright': '厄瓜多尔的观鸟区内的绯腰巨嘴鸟，厄瓜多尔 (© Tui De Roy/Minden Pictures)',\n",
       "   'copyrightlink': '/search?q=%e7%bb%af%e8%85%b0%e5%b7%a8%e5%98%b4%e9%b8%9f&form=hpcapt&mkt=zh-cn',\n",
       "   'drk': 1,\n",
       "   'enddate': '20180324',\n",
       "   'fullstartdate': '201803231600',\n",
       "   'hs': [],\n",
       "   'hsh': '99b8bc8f0857904072ba799f08db2c39',\n",
       "   'quiz': '/search?q=Bing+homepage+quiz&filters=WQOskey:%22HPQuiz_20180323_ToucanetEcuador%22&FORM=HPQUIZ',\n",
       "   'startdate': '20180323',\n",
       "   'top': 1,\n",
       "   'url': '/az/hprichbg/rb/ToucanetEcuador_ZH-CN11298988903_1920x1080.jpg',\n",
       "   'urlbase': '/az/hprichbg/rb/ToucanetEcuador_ZH-CN11298988903',\n",
       "   'wp': False},\n",
       "  {'bot': 1,\n",
       "   'copyright': '【今日世界气象日】秘鲁太平洋沿岸Yauca和Acarí河上空的云层 (© Joshua Stevens/NASA)',\n",
       "   'copyrightlink': '/search?q=%e4%b8%96%e7%95%8c%e6%b0%94%e8%b1%a1%e6%97%a5&form=hpcapt&mkt=zh-cn',\n",
       "   'drk': 1,\n",
       "   'enddate': '20180323',\n",
       "   'fullstartdate': '201803221600',\n",
       "   'hs': [],\n",
       "   'hsh': 'd806a9b1210db416eeb562fa0ab3bd4d',\n",
       "   'quiz': '/search?q=Bing+homepage+quiz&filters=WQOskey:%22HPQuiz_20180322_PeruCanyonClouds%22&FORM=HPQUIZ',\n",
       "   'startdate': '20180322',\n",
       "   'top': 1,\n",
       "   'url': '/az/hprichbg/rb/PeruCanyonClouds_ZH-CN10405307621_1920x1080.jpg',\n",
       "   'urlbase': '/az/hprichbg/rb/PeruCanyonClouds_ZH-CN10405307621',\n",
       "   'wp': False},\n",
       "  {'bot': 1,\n",
       "   'copyright': '萨尔茨堡附近的阿尔卑斯山内的Eibensee湖，奥地利  (© Christoph Oberschneider/Tandem Stills + Motion)',\n",
       "   'copyrightlink': '/search?q=Lake+Eibensee&form=hpcapt&mkt=zh-cn',\n",
       "   'drk': 1,\n",
       "   'enddate': '20180322',\n",
       "   'fullstartdate': '201803211600',\n",
       "   'hs': [],\n",
       "   'hsh': 'e7ef4adea3f98749ee2661e6209ad2b6',\n",
       "   'quiz': '/search?q=Bing+homepage+quiz&filters=WQOskey:%22HPQuiz_20180321_WorldWaterDay%22&FORM=HPQUIZ',\n",
       "   'startdate': '20180321',\n",
       "   'top': 1,\n",
       "   'url': '/az/hprichbg/rb/WorldWaterDay_ZH-CN11747740536_1920x1080.jpg',\n",
       "   'urlbase': '/az/hprichbg/rb/WorldWaterDay_ZH-CN11747740536',\n",
       "   'vid': {'audiopresent': True,\n",
       "    'caption': '视频：2018年“世界水日”(© Images: F1online digitale Bildagentur GmbH/Alamy; Christoph Oberschneider/Tandem Stills + Motion | Video: Nimia | Audio: Getty)',\n",
       "    'captionlink': '',\n",
       "    'dark': True,\n",
       "    'image': '//az29176.vo.msecnd.net/videocontent/WaterDay_1080_HD_ZH-CN46683123.jpg',\n",
       "    'loop': False,\n",
       "    'sources': [['mp4',\n",
       "      'video/mp4; codecs=\"avc1.42E01E, mp4a.40.2\"',\n",
       "      '//az29176.vo.msecnd.net/videocontent/WaterDay_768_ZH-CN.mp4'],\n",
       "     ['mp4hd',\n",
       "      'video/mp4; codecs=\"avc1.42E01E, mp4a.40.2\"',\n",
       "      '//az29176.vo.msecnd.net/videocontent/WaterDay_1080_HD_ZH-CN.mp4']]},\n",
       "   'wp': False},\n",
       "  {'bot': 1,\n",
       "   'copyright': '【今日春分】梅里雪山国家公园内一只以桃花为食的蓝喉太阳鸟，中国云南省 (© Dong Lei/Minden Pictures)',\n",
       "   'copyrightlink': '/search?q=%e6%98%a5%e5%88%86&form=hpcapt&mkt=zh-cn',\n",
       "   'drk': 1,\n",
       "   'enddate': '20180321',\n",
       "   'fullstartdate': '201803201600',\n",
       "   'hs': [],\n",
       "   'hsh': '489334a924dcdcce504e8159f03e4a77',\n",
       "   'quiz': '/search?q=Bing+homepage+quiz&filters=WQOskey:%22HPQuiz_20180320_Sunbird1%22&FORM=HPQUIZ',\n",
       "   'startdate': '20180320',\n",
       "   'top': 1,\n",
       "   'url': '/az/hprichbg/rb/Sunbird1_ZH-CN12058461588_1920x1080.jpg',\n",
       "   'urlbase': '/az/hprichbg/rb/Sunbird1_ZH-CN12058461588',\n",
       "   'wp': True},\n",
       "  {'bot': 1,\n",
       "   'copyright': '赫罗洛村附近的郁金香，荷兰德伦特省 (© plainpicture/Buiten-Beeld/Karin Broekhuijsen)',\n",
       "   'copyrightlink': '/search?q=%e8%8d%b7%e5%85%b0%e9%83%81%e9%87%91%e9%a6%99&form=hpcapt&mkt=zh-cn',\n",
       "   'drk': 1,\n",
       "   'enddate': '20180320',\n",
       "   'fullstartdate': '201803191600',\n",
       "   'hs': [],\n",
       "   'hsh': 'e384ff0bf9133dbf22102d6245656583',\n",
       "   'quiz': '/search?q=Bing+homepage+quiz&filters=WQOskey:%22HPQuiz_20180319_TulipsEquinox%22&FORM=HPQUIZ',\n",
       "   'startdate': '20180319',\n",
       "   'top': 1,\n",
       "   'url': '/az/hprichbg/rb/TulipsEquinox_ZH-CN11213785857_1920x1080.jpg',\n",
       "   'urlbase': '/az/hprichbg/rb/TulipsEquinox_ZH-CN11213785857',\n",
       "   'wp': True},\n",
       "  {'bot': 1,\n",
       "   'copyright': '三仙台龙桥，台湾台东县 (© Anthony Ko/Getty Images)',\n",
       "   'copyrightlink': '/search?q=%e4%b8%89%e4%bb%99%e5%8f%b0%e6%99%af%e5%8c%ba&form=hpcapt&mkt=zh-cn',\n",
       "   'drk': 1,\n",
       "   'enddate': '20180319',\n",
       "   'fullstartdate': '201803181600',\n",
       "   'hs': [],\n",
       "   'hsh': '2c1c162f934a302e90a37993b9d43599',\n",
       "   'quiz': '/search?q=Bing+homepage+quiz&filters=WQOskey:%22HPQuiz_20180318_DragonBridge%22&FORM=HPQUIZ',\n",
       "   'startdate': '20180318',\n",
       "   'top': 1,\n",
       "   'url': '/az/hprichbg/rb/DragonBridge_ZH-CN12321283639_1920x1080.jpg',\n",
       "   'urlbase': '/az/hprichbg/rb/DragonBridge_ZH-CN12321283639',\n",
       "   'wp': False},\n",
       "  {'bot': 1,\n",
       "   'copyright': '圣诞树路和双子峰，美国旧金山 (© Terence Chang/Getty Images)',\n",
       "   'copyrightlink': '/search?q=%e5%8f%8c%e5%b3%b0%e5%b1%b1(%e7%be%8e%e5%9b%bd)+&form=hpcapt&mkt=zh-cn',\n",
       "   'drk': 1,\n",
       "   'enddate': '20180318',\n",
       "   'fullstartdate': '201803171600',\n",
       "   'hs': [],\n",
       "   'hsh': 'be019c1baf8b6c2461e562c63b3cb11b',\n",
       "   'quiz': '/search?q=Bing+homepage+quiz&filters=WQOskey:%22HPQuiz_20180317_XmasTreeRoad%22&FORM=HPQUIZ',\n",
       "   'startdate': '20180317',\n",
       "   'top': 1,\n",
       "   'url': '/az/hprichbg/rb/XmasTreeRoad_ZH-CN11556502034_1920x1080.jpg',\n",
       "   'urlbase': '/az/hprichbg/rb/XmasTreeRoad_ZH-CN11556502034',\n",
       "   'wp': False},\n",
       "  {'bot': 1,\n",
       "   'copyright': 'Ross Errilly Friary，爱尔兰戈尔韦郡 (© plainpicture)',\n",
       "   'copyrightlink': '/search?q=Ross+Errilly+Friary&form=hpcapt&mkt=zh-cn',\n",
       "   'drk': 1,\n",
       "   'enddate': '20180317',\n",
       "   'fullstartdate': '201803161600',\n",
       "   'hs': [],\n",
       "   'hsh': 'eec253a2d68585f86cab82814afa0636',\n",
       "   'quiz': '/search?q=Bing+homepage+quiz&filters=WQOskey:%22HPQuiz_20180316_RossErrilly%22&FORM=HPQUIZ',\n",
       "   'startdate': '20180316',\n",
       "   'top': 1,\n",
       "   'url': '/az/hprichbg/rb/RossErrilly_ZH-CN11204408260_1920x1080.jpg',\n",
       "   'urlbase': '/az/hprichbg/rb/RossErrilly_ZH-CN11204408260',\n",
       "   'wp': False}],\n",
       " 'tooltips': {'loading': '正在加载...',\n",
       "  'next': '下一个图像',\n",
       "  'pause': '暂停视频',\n",
       "  'play': '播放视频',\n",
       "  'previous': '上一个图像',\n",
       "  'walle': '此图片不能下载用作壁纸。',\n",
       "  'walls': '下载今日美图。仅限用作桌面壁纸。'}}"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "with open('test-data3.json', 'rb') as inf:\n",
    "    raw = json.load(inf)\n",
    "raw"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>bot</th>\n",
       "      <th>copyright</th>\n",
       "      <th>copyrightlink</th>\n",
       "      <th>drk</th>\n",
       "      <th>enddate</th>\n",
       "      <th>fullstartdate</th>\n",
       "      <th>hs</th>\n",
       "      <th>hsh</th>\n",
       "      <th>quiz</th>\n",
       "      <th>startdate</th>\n",
       "      <th>top</th>\n",
       "      <th>url</th>\n",
       "      <th>urlbase</th>\n",
       "      <th>vid</th>\n",
       "      <th>wp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>厄瓜多尔的观鸟区内的绯腰巨嘴鸟，厄瓜多尔 (© Tui De Roy/Minden Pict...</td>\n",
       "      <td>/search?q=%e7%bb%af%e8%85%b0%e5%b7%a8%e5%98%b4...</td>\n",
       "      <td>1</td>\n",
       "      <td>20180324</td>\n",
       "      <td>201803231600</td>\n",
       "      <td>[]</td>\n",
       "      <td>99b8bc8f0857904072ba799f08db2c39</td>\n",
       "      <td>/search?q=Bing+homepage+quiz&amp;filters=WQOskey:%...</td>\n",
       "      <td>20180323</td>\n",
       "      <td>1</td>\n",
       "      <td>/az/hprichbg/rb/ToucanetEcuador_ZH-CN112989889...</td>\n",
       "      <td>/az/hprichbg/rb/ToucanetEcuador_ZH-CN11298988903</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>【今日世界气象日】秘鲁太平洋沿岸Yauca和Acarí河上空的云层 (© Joshua St...</td>\n",
       "      <td>/search?q=%e4%b8%96%e7%95%8c%e6%b0%94%e8%b1%a1...</td>\n",
       "      <td>1</td>\n",
       "      <td>20180323</td>\n",
       "      <td>201803221600</td>\n",
       "      <td>[]</td>\n",
       "      <td>d806a9b1210db416eeb562fa0ab3bd4d</td>\n",
       "      <td>/search?q=Bing+homepage+quiz&amp;filters=WQOskey:%...</td>\n",
       "      <td>20180322</td>\n",
       "      <td>1</td>\n",
       "      <td>/az/hprichbg/rb/PeruCanyonClouds_ZH-CN10405307...</td>\n",
       "      <td>/az/hprichbg/rb/PeruCanyonClouds_ZH-CN10405307621</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>萨尔茨堡附近的阿尔卑斯山内的Eibensee湖，奥地利  (© Christoph Ober...</td>\n",
       "      <td>/search?q=Lake+Eibensee&amp;form=hpcapt&amp;mkt=zh-cn</td>\n",
       "      <td>1</td>\n",
       "      <td>20180322</td>\n",
       "      <td>201803211600</td>\n",
       "      <td>[]</td>\n",
       "      <td>e7ef4adea3f98749ee2661e6209ad2b6</td>\n",
       "      <td>/search?q=Bing+homepage+quiz&amp;filters=WQOskey:%...</td>\n",
       "      <td>20180321</td>\n",
       "      <td>1</td>\n",
       "      <td>/az/hprichbg/rb/WorldWaterDay_ZH-CN11747740536...</td>\n",
       "      <td>/az/hprichbg/rb/WorldWaterDay_ZH-CN11747740536</td>\n",
       "      <td>{'sources': [['mp4', 'video/mp4; codecs=\"avc1....</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>【今日春分】梅里雪山国家公园内一只以桃花为食的蓝喉太阳鸟，中国云南省 (© Dong Lei...</td>\n",
       "      <td>/search?q=%e6%98%a5%e5%88%86&amp;form=hpcapt&amp;mkt=z...</td>\n",
       "      <td>1</td>\n",
       "      <td>20180321</td>\n",
       "      <td>201803201600</td>\n",
       "      <td>[]</td>\n",
       "      <td>489334a924dcdcce504e8159f03e4a77</td>\n",
       "      <td>/search?q=Bing+homepage+quiz&amp;filters=WQOskey:%...</td>\n",
       "      <td>20180320</td>\n",
       "      <td>1</td>\n",
       "      <td>/az/hprichbg/rb/Sunbird1_ZH-CN12058461588_1920...</td>\n",
       "      <td>/az/hprichbg/rb/Sunbird1_ZH-CN12058461588</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>赫罗洛村附近的郁金香，荷兰德伦特省 (© plainpicture/Buiten-Beeld...</td>\n",
       "      <td>/search?q=%e8%8d%b7%e5%85%b0%e9%83%81%e9%87%91...</td>\n",
       "      <td>1</td>\n",
       "      <td>20180320</td>\n",
       "      <td>201803191600</td>\n",
       "      <td>[]</td>\n",
       "      <td>e384ff0bf9133dbf22102d6245656583</td>\n",
       "      <td>/search?q=Bing+homepage+quiz&amp;filters=WQOskey:%...</td>\n",
       "      <td>20180319</td>\n",
       "      <td>1</td>\n",
       "      <td>/az/hprichbg/rb/TulipsEquinox_ZH-CN11213785857...</td>\n",
       "      <td>/az/hprichbg/rb/TulipsEquinox_ZH-CN11213785857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>三仙台龙桥，台湾台东县 (© Anthony Ko/Getty Images)</td>\n",
       "      <td>/search?q=%e4%b8%89%e4%bb%99%e5%8f%b0%e6%99%af...</td>\n",
       "      <td>1</td>\n",
       "      <td>20180319</td>\n",
       "      <td>201803181600</td>\n",
       "      <td>[]</td>\n",
       "      <td>2c1c162f934a302e90a37993b9d43599</td>\n",
       "      <td>/search?q=Bing+homepage+quiz&amp;filters=WQOskey:%...</td>\n",
       "      <td>20180318</td>\n",
       "      <td>1</td>\n",
       "      <td>/az/hprichbg/rb/DragonBridge_ZH-CN12321283639_...</td>\n",
       "      <td>/az/hprichbg/rb/DragonBridge_ZH-CN12321283639</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>圣诞树路和双子峰，美国旧金山 (© Terence Chang/Getty Images)</td>\n",
       "      <td>/search?q=%e5%8f%8c%e5%b3%b0%e5%b1%b1(%e7%be%8...</td>\n",
       "      <td>1</td>\n",
       "      <td>20180318</td>\n",
       "      <td>201803171600</td>\n",
       "      <td>[]</td>\n",
       "      <td>be019c1baf8b6c2461e562c63b3cb11b</td>\n",
       "      <td>/search?q=Bing+homepage+quiz&amp;filters=WQOskey:%...</td>\n",
       "      <td>20180317</td>\n",
       "      <td>1</td>\n",
       "      <td>/az/hprichbg/rb/XmasTreeRoad_ZH-CN11556502034_...</td>\n",
       "      <td>/az/hprichbg/rb/XmasTreeRoad_ZH-CN11556502034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>Ross Errilly Friary，爱尔兰戈尔韦郡 (© plainpicture)</td>\n",
       "      <td>/search?q=Ross+Errilly+Friary&amp;form=hpcapt&amp;mkt=...</td>\n",
       "      <td>1</td>\n",
       "      <td>20180317</td>\n",
       "      <td>201803161600</td>\n",
       "      <td>[]</td>\n",
       "      <td>eec253a2d68585f86cab82814afa0636</td>\n",
       "      <td>/search?q=Bing+homepage+quiz&amp;filters=WQOskey:%...</td>\n",
       "      <td>20180316</td>\n",
       "      <td>1</td>\n",
       "      <td>/az/hprichbg/rb/RossErrilly_ZH-CN11204408260_1...</td>\n",
       "      <td>/az/hprichbg/rb/RossErrilly_ZH-CN11204408260</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   bot                                          copyright  \\\n",
       "0    1  厄瓜多尔的观鸟区内的绯腰巨嘴鸟，厄瓜多尔 (© Tui De Roy/Minden Pict...   \n",
       "1    1  【今日世界气象日】秘鲁太平洋沿岸Yauca和Acarí河上空的云层 (© Joshua St...   \n",
       "2    1  萨尔茨堡附近的阿尔卑斯山内的Eibensee湖，奥地利  (© Christoph Ober...   \n",
       "3    1  【今日春分】梅里雪山国家公园内一只以桃花为食的蓝喉太阳鸟，中国云南省 (© Dong Lei...   \n",
       "4    1  赫罗洛村附近的郁金香，荷兰德伦特省 (© plainpicture/Buiten-Beeld...   \n",
       "5    1            三仙台龙桥，台湾台东县 (© Anthony Ko/Getty Images)   \n",
       "6    1      圣诞树路和双子峰，美国旧金山 (© Terence Chang/Getty Images)   \n",
       "7    1       Ross Errilly Friary，爱尔兰戈尔韦郡 (© plainpicture)   \n",
       "\n",
       "                                       copyrightlink  drk   enddate  \\\n",
       "0  /search?q=%e7%bb%af%e8%85%b0%e5%b7%a8%e5%98%b4...    1  20180324   \n",
       "1  /search?q=%e4%b8%96%e7%95%8c%e6%b0%94%e8%b1%a1...    1  20180323   \n",
       "2      /search?q=Lake+Eibensee&form=hpcapt&mkt=zh-cn    1  20180322   \n",
       "3  /search?q=%e6%98%a5%e5%88%86&form=hpcapt&mkt=z...    1  20180321   \n",
       "4  /search?q=%e8%8d%b7%e5%85%b0%e9%83%81%e9%87%91...    1  20180320   \n",
       "5  /search?q=%e4%b8%89%e4%bb%99%e5%8f%b0%e6%99%af...    1  20180319   \n",
       "6  /search?q=%e5%8f%8c%e5%b3%b0%e5%b1%b1(%e7%be%8...    1  20180318   \n",
       "7  /search?q=Ross+Errilly+Friary&form=hpcapt&mkt=...    1  20180317   \n",
       "\n",
       "  fullstartdate  hs                               hsh  \\\n",
       "0  201803231600  []  99b8bc8f0857904072ba799f08db2c39   \n",
       "1  201803221600  []  d806a9b1210db416eeb562fa0ab3bd4d   \n",
       "2  201803211600  []  e7ef4adea3f98749ee2661e6209ad2b6   \n",
       "3  201803201600  []  489334a924dcdcce504e8159f03e4a77   \n",
       "4  201803191600  []  e384ff0bf9133dbf22102d6245656583   \n",
       "5  201803181600  []  2c1c162f934a302e90a37993b9d43599   \n",
       "6  201803171600  []  be019c1baf8b6c2461e562c63b3cb11b   \n",
       "7  201803161600  []  eec253a2d68585f86cab82814afa0636   \n",
       "\n",
       "                                                quiz startdate  top  \\\n",
       "0  /search?q=Bing+homepage+quiz&filters=WQOskey:%...  20180323    1   \n",
       "1  /search?q=Bing+homepage+quiz&filters=WQOskey:%...  20180322    1   \n",
       "2  /search?q=Bing+homepage+quiz&filters=WQOskey:%...  20180321    1   \n",
       "3  /search?q=Bing+homepage+quiz&filters=WQOskey:%...  20180320    1   \n",
       "4  /search?q=Bing+homepage+quiz&filters=WQOskey:%...  20180319    1   \n",
       "5  /search?q=Bing+homepage+quiz&filters=WQOskey:%...  20180318    1   \n",
       "6  /search?q=Bing+homepage+quiz&filters=WQOskey:%...  20180317    1   \n",
       "7  /search?q=Bing+homepage+quiz&filters=WQOskey:%...  20180316    1   \n",
       "\n",
       "                                                 url  \\\n",
       "0  /az/hprichbg/rb/ToucanetEcuador_ZH-CN112989889...   \n",
       "1  /az/hprichbg/rb/PeruCanyonClouds_ZH-CN10405307...   \n",
       "2  /az/hprichbg/rb/WorldWaterDay_ZH-CN11747740536...   \n",
       "3  /az/hprichbg/rb/Sunbird1_ZH-CN12058461588_1920...   \n",
       "4  /az/hprichbg/rb/TulipsEquinox_ZH-CN11213785857...   \n",
       "5  /az/hprichbg/rb/DragonBridge_ZH-CN12321283639_...   \n",
       "6  /az/hprichbg/rb/XmasTreeRoad_ZH-CN11556502034_...   \n",
       "7  /az/hprichbg/rb/RossErrilly_ZH-CN11204408260_1...   \n",
       "\n",
       "                                             urlbase  \\\n",
       "0   /az/hprichbg/rb/ToucanetEcuador_ZH-CN11298988903   \n",
       "1  /az/hprichbg/rb/PeruCanyonClouds_ZH-CN10405307621   \n",
       "2     /az/hprichbg/rb/WorldWaterDay_ZH-CN11747740536   \n",
       "3          /az/hprichbg/rb/Sunbird1_ZH-CN12058461588   \n",
       "4     /az/hprichbg/rb/TulipsEquinox_ZH-CN11213785857   \n",
       "5      /az/hprichbg/rb/DragonBridge_ZH-CN12321283639   \n",
       "6      /az/hprichbg/rb/XmasTreeRoad_ZH-CN11556502034   \n",
       "7       /az/hprichbg/rb/RossErrilly_ZH-CN11204408260   \n",
       "\n",
       "                                                 vid     wp  \n",
       "0                                                NaN  False  \n",
       "1                                                NaN  False  \n",
       "2  {'sources': [['mp4', 'video/mp4; codecs=\"avc1....  False  \n",
       "3                                                NaN   True  \n",
       "4                                                NaN   True  \n",
       "5                                                NaN  False  \n",
       "6                                                NaN  False  \n",
       "7                                                NaN  False  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.DataFrame(raw['images'])\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
